
export default {
  data: {
    // 用户档案信息
    userinfo: {
      json: {
        f_userinfo_id: '用户编号',
        // f_user_id: '表编号',
        f_user_name: ' 用户姓名/单位名称',
        f_area: '区',
        f_slice_area: '片区/管理站',
        f_adjustable_name: '调压箱',
        f_residential_area: '小区',
        f_user_state: '用户状态',
        f_balance: '用户账户结余',
        f_address: '地址',
        f_user_type: '用户类型',
        f_gasproperties: '用气性质',
        f_street: '街道',
        f_building: '楼号',
        f_unit: '单元号',
        f_floor: '楼层',
        f_room: '门牌号',
        f_credentials: '证件类型',
        f_idnumber: '证件号码',
        f_user_phone: '电话',
        // f_open_id: '微信绑定标识',
        f_cost_type: '缴费类型',
        f_contract_id: '合同编号',
        f_operator: '操作人(建档人)',
        f_createfile_date: '建档日期'
      },
      url: 'rs/sql/userinfo_query',
      condition: '',
      orderitem: 'f_createfile_date DESC',
      matchitem: 't.f_userinfo_id = u.f_userinfo_id'
    },
    // 售气收费
    sellinggas: {
      json: {
        f_userinfo_id: '用户编号',
        f_user_name: '用户名称 ',
        f_pregas: '购气量',
        f_preamount: '应交金额',
        f_collection: '收 款',
        f_payment: '付款方式',
        f_balance: '上期结余',
        f_curbalance: '本期结余',
        f_user_type: '用户类型',
        f_gasproperties: '用气性质',
        f_meter_type: '气表类型',
        f_user_id: '表编号',
        f_last_tablebase: '上期底数',
        f_tablebase: '本期底数',
        f_surplus_gas: '剩余气量',
        f_charge_state: '收费状态',
        f_delivery_date: '缴费日期',
        f_delaypay: '滞纳金',
        f_meternumber: '表号',
        // f_price_id: '气价编号',
        f_meter_brand: '气表品牌',
        f_meter_style: '气表型号',
        f_charge_type: '收费类型',
        f_address: '地址',
        f_outlets: '营业网点',
        f_operator: '操作人',
        f_bill_id: '发票号'
        // id: '操作id'
      },
      sums: {
        f_pregas: 'f_pregas',
        f_preamount: 'f_preamount '
      },
      url: 'rs/sql/querySell_query',
      condition: '',
      orderitem: 'f_delivery_date DESC',
      matchitem: 't.f_user_id = u.f_user_id'
    },
    // 操作记录
    record: {
      json: {
        // id: 'id',
        f_userinfo_id: '用户编号',
        f_operat_type: ' 操作类型',
        f_describe: '操作描述',
        f_state: '操作状态',
        f_operator: '操作人',
        f_operate_date: '操作日期'
      },
      condition: '',
      orderitem: 'f_operate_date DESC',
      matchitem: 't.f_userinfo_id = u.f_userinfo_id'
    },
    // 抄表
    handplan: {
      json: {
        f_userinfo_id: '用户编号',
        f_user_name: '用户姓名',
        f_address: '地址',
        f_hand_date: '抄表日期',
        f_last_tablebase: '上期指数',
        f_tablebase: '本期指数 ',
        f_oughtamount: '应交气量',
        f_oughtfee: '应交金额 ',
        f_whether_pay: '是否缴费',
        f_meter_state: '抄表单状态 ',
        f_meternumber: '表号',
        // f_price_id: '气价编号',
        // f_sell_id: ' 收费表关联id',
        f_user_type: '用户类型 ',
        f_gasproperties: '用气性质',
        f_meter_brand: '气表品牌',
        f_meter_style: '气表型号',
        f_inputtor: '抄表员',
        f_input_date: '录入日期 ',
        f_end_date: '截止日期',
        f_operator: '操作人'
        // f_filiale: '分公司 ',
        // f_outlets: '营业网点'
      },
      sums: {
        f_oughtamount: 'f_oughtamount',
        f_oughtfee: 'f_oughtfee '
      },
      condition: '',
      orderitem: 'f_hand_date DESC',
      matchitem: 't.f_user_id = u.f_user_id'
    },
    // 换表管理
    changemeter: {
      json: {
        // id: 'id',
        f_userinfo_id: '用户编号',
        f_user_name: '用户姓名',
        f_changemeter_type: '换表类型',
        f_changemeter_fee: '换表表费',
        f_meternumber: '旧表号',
        f_newmeternumber: '新表号',
        // f_metertitles: '旧表封号',
        // f_newmetertitles: '新表封号',
        // f_card_password: '卡密码',
        // f_newcard_password: '新卡密码',
        f_remanent_gas: '旧表剩余补气量',
        f_newremanent_gas: '新表剩余补气量',
        f_changemeter_state: '换表状态',
        f_meter_base: '旧表底数',
        f_newmeter_base: '新表底数',
        f_initial_base: '初始气表底数',
        f_newinitial_base: '新初始气表底数',
        // f_times: '写卡次数',
        // f_newtimes: '新写卡次数',
        f_outlets: '营业网点',
        f_operator: '操作人',
        f_operate_date: '操作日期 ',
        f_meter_classify: '气表分类',
        f_newmeter_classify: '新气表分类',
        // f_meterid: '用户号 ',
        // f_newmeterid: '新用户号 ',
        // f_table_state: '旧表状态',
        // f_newtable_state: '新表状态',
        // f_valve_state: '旧表阀门状态',
        // f_newvalve_state: '新表阀门状态',
        // f_gasbrand_id: '气表品牌关联',
        // f_gasmodel_id: '气表型号关联',
        // f_newgasbrand_id: '新气表品牌关联',
        // f_newgasmodel_id: '新气表型号关联',
        // f_filiale: '分公司',
        f_user_id: '表编号',
        f_card_id: '旧卡号',
        f_newcard_id: '新卡号'

      },
      condition: '',
      orderitem: 'f_operate_date DESC',
      matchitem: 't.f_user_id = u.f_user_id'
    },
    // 变更明细
    infochange: {
      json: {
        id: 'id',
        f_user_id: '用户表编号',
        f_userinfo_id: '用户编号',
        f_field_name: '修改字段',
        f_used_content: '旧修改内容',
        f_new_content: '新修改内容',
        f_change_id: '变更操作记录ID'
      },
      condition: '',
      orderitem: 'id DESC',
      matchitem: 't.f_userinfo_id = u.f_userinfo_id'
    },
    // 变更操作表
    recordchange: {
      json: {
        id: 'id',
        f_change_content: '变更后内容',
        f_change_type: '变更类型',
        f_change_count: '变更数',
        f_reality_count: '实际变更数',
        f_operator: '操作人',
        f_operate_date: '操作日期',
        f_change_cause: '变更原因'
      },
      condition: '',
      orderitem: 'f_operate_date DESC',
      matchitem: 't.f_userinfo_id = u.f_userinfo_id'
    },
    // 过户
    transfer: {
      json: {
        // id: 'id',
        f_userinfo_id: '用户编号',
        // f_user_id: '用户表编号',
        f_user_name: '用户姓名',
        f_user_phone: '电话',
        f_idnumber: '身份证号',
        f_newuser_name: '新用户姓名',
        f_newuser_phone: '新用户电话',
        f_newidnumber: '新身份证号',
        f_transfer_state: '过户状态',
        f_transfer_fees: '过户费',
        // f_bank_accopen: '银行开户名',
        // f_bank_name: '银行名',
        // f_bank_account: '银行开户账号',
        // f_newbank_accopen: '新银行开户名',
        // f_newbank_name: '新银行名',
        // f_newbank_account: '新银行开户账号',
        f_operator: '操作人',

        // f_filiale: '分公司',
        f_outlets: '营业网点 ',
        f_note: '备注',
        f_operate_date: '过户日期 '
      },
      url: 'rs/sql/transfer_query',
      condition: '',
      orderitem: 'f_operate_date DESC',
      matchitem: 't.f_userinfo_id = u.f_userinfo_id'
    },
    // 冲正
    correctrecord: {
      json: {
        // id: 'id',
        f_user_id: '用户表编号',
        f_user_name: '用户/单位名称',
        f_correct_type: '冲正类型',
        // f_correct_id: '冲正编号',
        f_correct_collection: '冲正金额',
        f_correct_gas: '冲正气量',
        f_correct_cause: '冲正原因',
        f_correct_state: '冲正状态 ',
        // f_filiale: '分公司',
        f_outlets: '营业网点',
        f_operator: '操作人',
        f_correct_date: '冲正时间'
      },
      condition: '',
      orderitem: 'f_correct_date DESC',
      matchitem: ' t.f_user_id = u.f_user_id'
    },
    // 补卡
    fillcard: {
      json: {
        // id: 'id',
        f_userinfo_id: '用户编号',
        f_user_id: '表编号',
        f_user_name: '用户姓名',
        f_fillcard_type: '补卡类型',
        // f_card_id: '卡号',
        f_cardfees: '卡费',
        f_reason: '补卡原因',
        f_fillcard_state: '补卡状态',
        // f_filiale: '分公司',
        f_outlets: '营业网点',
        f_fillcard_date: '补卡日期'
      },
      condition: '',
      orderitem: 'f_fillcard_date DESC',
      matchitem: 't.f_user_id = u.f_user_id'
    },
    // 补气
    fillgas: {
      json: {
        // id: 'id',
        f_userinfo_id: '用户编号',
        f_user_id: '表编号',
        f_user_name: '用户姓名',
        // f_card_id: '卡号',
        f_lastremain_fillgas: '上次剩余补气量',
        f_fillgas: '本次补气量',
        f_theremain_fillgas: '本次剩余补气量',
        f_reason: '补气原因',
        f_fillgas_type: '补气类型',
        f_fillgas_state: '补气状态',
        // f_filiale: '分公司',
        f_outlets: '营业网点',
        f_fillgas_date: '补气日期'
      },
      condition: '',
      orderitem: 'f_fillgas_date DESC',
      matchitem: 't.f_user_id = u.f_user_id'
    },
    handsell: {
      json: {
        f_user_id: '表编号',
        f_userinfo_id: '用户编号',
        f_user_name: '用户姓名',
        f_user_phone: '用户电话',
        f_contract_id: '合同编号',
        handdate: '抄表日期',
        f_delivery_date: '缴费日期',
        f_payment: '付款方式',
        f_last_tablebase: '上次指数',
        f_tablebase: '本次指数',
        f_pregas:	'用气量',
        f_preamount: '用气金额',
        f_balance: '上期结余',
        f_collection: '实收款',
        f_curbalance: '本期结余',
        f_haircut_gas: '扣减气量',
        f_surplus_gas: '剩余气量'
      },
      condition: '',
      orderitem: 'f_delivery_date DESC',
      matchitem: '',
      url: 'rs/sql/handSel_queryl'
    },
    // 其他收费
    othercharge: {
      json: {
        // id: 'id',
        // f_user_id: '用户表编号',
        f_userinfo_id: '用户编号',
        f_user_name: '用户姓名',
        f_brand_spec: '收费类型',
        // f_charge_type: '收费类型',
        f_number: '数量',
        f_unitprice: '单价',
        f_collection: '收款',
        f_charge_state: '收费状态',
        f_operator: '操作人',
        // f_filiale: '分公司',
        f_outlets: '营业网点',
        f_operate_date: '操作日期 '
      },
      url: 'rs/sql/othercharge_query',
      condition: '',
      orderitem: 'f_operate_date DESC',
      matchitem: 't.f_userinfo_id = u.f_userinfo_id'
    },
    // 撤销
    recordcancel: {
      json: {
        f_cancel_name: '撤销人',
        f_cancel_reason: '撤销原因',
        f_operat_type: '操作类型',
        f_describe: '操作描述',
        f_userinfo_id: '用户编号',
        f_user_name: '用户姓名',
        f_user_id: '表编号',
        f_address: '用户地址',
        f_user_phone: '用户电话',
        // f_user_state: '用户状态',
        // f_user_type: '用户类型',
        // f_filiale: '分公司',
        f_outlets: '营业网点',
        f_cancel_date: '撤销日期'
      },
      url: 'rs/sql/recordcancel_query',
      condition: '',
      orderitem: 'f_cancel_date DESC',
      matchitem: 't.f_userinfo_id = u.f_userinfo_id'
    }
  }
}
